//
//  SQLiteDataBaseManger.h
//  UI18-SQLite(数据库)
//
//  Created by 韩旭 on 16/8/8.
//  Copyright © 2016年 lanou. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "Student.h"
NS_ASSUME_NONNULL_BEGIN

@interface SQLiteDataBaseManger : NSObject
{
    sqlite3 *dbPoint;
}
//单利方法，一个工程中只包含着一个对象
+ (SQLiteDataBaseManger *)shareManger;
- (BOOL)openSQLite3;
- (BOOL)closeSQLite3;

- (BOOL)creatTable;
//添加数据
- (BOOL)insertStu:(Student *)stu;
//删除数据
- (BOOL)deleteStu:(Student *)stu;
//删除全部
- (BOOL)deleteAll;

//更新数据
- (BOOL)upDateOldName:(NSString *)oldName
              newName:(NSString *)newName;
- (__kindof NSArray *)selectName;
@end
NS_ASSUME_NONNULL_END
